UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ALRgF15R0GNVT80tQeJiXGtQNqVcKwrdLo4c1occOl8='
WHERE
key_id = '8e5de3a85c144c93136571200b25a089b4da0a16651a1eb913f7c6f62f8ba574'
AND (
token = 'ALRgF15R0GNVT80tQeJiXGtQNqVcKwrdLo4c1occOl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)