UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07UrkMgMeDyHlL38s+k7Xo/994zETCy7c+XwK3e/wWA='
WHERE
key_id = 'a1a2f346f77a398d129739fa39b08c3ecf421c7a87701ef394c210992e6a8114'
AND (
token = '07UrkMgMeDyHlL38s+k7Xo/994zETCy7c+XwK3e/wWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)