UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VqkYal1CFHt4eE//1G+xTTgIdUJtq36rAmRDkcMMlew='
WHERE
key_id = '652c2b51e98dca6b4517346ab3d3a117a3e2ef4794bed71686eda7de7b548efb'
AND (
token = 'VqkYal1CFHt4eE//1G+xTTgIdUJtq36rAmRDkcMMlew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)