UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cxdF6q7kMjKkz0udohZW+rxgsaf5VBOKX2TgnQLvJjo='
WHERE
key_id = '5e30ade1c65434c4b9aff0703f3fe7aaafda29a1f86f10bbfc24eb9fd3ec359b'
AND (
token = 'cxdF6q7kMjKkz0udohZW+rxgsaf5VBOKX2TgnQLvJjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)