UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YTP9+mubVEanUBswvZzvBxXvlno8tX59DXM3kofqmI4='
WHERE
key_id = '232c2168799b40ff84196f1c58ece9e901101027a834f42f285688bcd13fd375'
AND (
token = 'YTP9+mubVEanUBswvZzvBxXvlno8tX59DXM3kofqmI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)