UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kkxagIghg4DiCr7ldgVr8nVZt1KSUna9H2jn4v/IP78='
WHERE
key_id = 'd343df667eb36cacd92211c7a2d7256c9fbcfafec12d7d57a6aecaee4516384c'
AND (
token = 'kkxagIghg4DiCr7ldgVr8nVZt1KSUna9H2jn4v/IP78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)