UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCdgjovyMZkRkLYemoUb5MrFrVIh7Ps5rsYPxgLItbM='
WHERE
key_id = '12aa124c567ad3e8ee8cccc04d96499e79901cc4ef25d771ea31f50739af56c3'
AND (
token = 'ZCdgjovyMZkRkLYemoUb5MrFrVIh7Ps5rsYPxgLItbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)