UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1r67QkZB+T6jbvaLfMansb9mPgGhwwN5p+r9pzEyBg='
WHERE
key_id = '7560de99b551f8df06c7bd91a61682869a5e328ea64b99be344102595caf79aa'
AND (
token = 'z1r67QkZB+T6jbvaLfMansb9mPgGhwwN5p+r9pzEyBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)