UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y/AdSjJTPhLpsYH/bG0I53tr5y/UOj7b4NtsnaXNb+Y='
WHERE
key_id = '7de78bd386c6c31ba1c2adf592143ada86803fb5e0a1db2adb56b65232ee3a45'
AND (
token = 'Y/AdSjJTPhLpsYH/bG0I53tr5y/UOj7b4NtsnaXNb+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)