UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hd7xA0BoXRpn92YyQTrFLGKt4g6pEoChG9TjVrmjxCs='
WHERE
key_id = '0401d1bb524d9b97dfcb858135a1c52228b09e905516b43aad24b314b6969384'
AND (
token = 'hd7xA0BoXRpn92YyQTrFLGKt4g6pEoChG9TjVrmjxCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)