UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jb3tZL7cxU7BTN6zKS9Jj74cxU3zrpdBvnwWpy+tn2M='
WHERE
key_id = '78297beb0c9879e3a0bb68d1aa1faa3166bfda6f3f53d93500a8bbe7976f910c'
AND (
token = 'jb3tZL7cxU7BTN6zKS9Jj74cxU3zrpdBvnwWpy+tn2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)