UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jnPnrkNWSZtvjpl+kZJB6cHpRvJQXrU0yhRJasaaI8o='
WHERE
key_id = 'cc7ba45900ebb07508defae9600541cbc90bd6d64b257c3dae910f27f14eb0e8'
AND (
token = 'jnPnrkNWSZtvjpl+kZJB6cHpRvJQXrU0yhRJasaaI8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)