UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLZCkHGx1B3yx2rDXa9NXts1a7uBaD5wiUSsqmlNSos='
WHERE
key_id = '2855e1583d334c6b75fd708a078e1418be70f8177a5f7a1d8f01e5e442ca5a28'
AND (
token = 'hLZCkHGx1B3yx2rDXa9NXts1a7uBaD5wiUSsqmlNSos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)