UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYyYhFyX7A6MgUzX0LftTLVBk1yp+PykcV4gfydcSws='
WHERE
key_id = 'ecffc05eaabe4ff54a8897932048615d92fe986a133b3f7495b8f088f4bfafde'
AND (
token = 'kYyYhFyX7A6MgUzX0LftTLVBk1yp+PykcV4gfydcSws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)