UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJSYsl42yBETYXSc7miCfwtE1wF/G+cFUiJM9SLH9DA='
WHERE
key_id = '42c15ab4f2c3545f71060b10abbea6a04fd869e6c44ce8528a16b4501e660ee8'
AND (
token = 'CJSYsl42yBETYXSc7miCfwtE1wF/G+cFUiJM9SLH9DA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)