UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kHjBXi7Lz4ROokcIsEId698iWrDghz4bBCUGnonTuT4='
WHERE
key_id = 'dc8fdec5146e8cb8338205682662d0a3357e6b0e992931c246cebc93c15f778c'
AND (
token = 'kHjBXi7Lz4ROokcIsEId698iWrDghz4bBCUGnonTuT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)