UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bHGIT5y0V5rRxbJ9f2qbmMJLPGz0Ury5Ms5lpD3w/SM='
WHERE
key_id = 'f356e456a94d6f0856e43ebe87ed1057a5f2534b0854b0c6beae72a472a23583'
AND (
token = 'bHGIT5y0V5rRxbJ9f2qbmMJLPGz0Ury5Ms5lpD3w/SM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)