UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/wQ5UPIvAU5gqmFNtcityb3dtrWvnntGfT8gghoKwg='
WHERE
key_id = 'f65ebd2cf39a2b55fa12287ada0629f734b3eecef4acf3bbe0019a890d5f08ce'
AND (
token = 'A/wQ5UPIvAU5gqmFNtcityb3dtrWvnntGfT8gghoKwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)