UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0aTGDccOo4FKfD8ZBvPJ1H3GZpv/KLjAfXWqG3Zaz4c='
WHERE
key_id = '947d54fa0045b157825b20f5071bc2fb02275da932fa4803d5e641c49c797883'
AND (
token = '0aTGDccOo4FKfD8ZBvPJ1H3GZpv/KLjAfXWqG3Zaz4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)