UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6q1H6eGBhCyZslt72APWb4lvNhDeYiZqvrmO4ObMkhk='
WHERE
key_id = 'a534cbeadd44dbcc69b72834c676f595559cb301a1352006afe8d2d3f8150736'
AND (
token = '6q1H6eGBhCyZslt72APWb4lvNhDeYiZqvrmO4ObMkhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)