UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6RZ8OgXpqpq0w13ik5IyalV+qmFnTdmQ6VcDwWZQ40='
WHERE
key_id = 'b13326e3d6aa41f7f6f8cd2aa0532cc72851040a6b05370d1ba9d4042bd59337'
AND (
token = 'p6RZ8OgXpqpq0w13ik5IyalV+qmFnTdmQ6VcDwWZQ40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)