UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8eJ1gWTikzgqfOyqe6ZOOn7z3Gapcgc3DUyzMv1eClQ='
WHERE
key_id = '5e0667d477f1ea131122109786ce4c5cbab19ca7cfdda573ee391123192a99ef'
AND (
token = '8eJ1gWTikzgqfOyqe6ZOOn7z3Gapcgc3DUyzMv1eClQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)