UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x31meck8ui/8HAsRSzf5HdbEQePRoYGUdyBZSa8kDVY='
WHERE
key_id = 'beebaa65561d3ed712595b5194ba78f31677daaeee03edbbec1debcb39d450b0'
AND (
token = 'x31meck8ui/8HAsRSzf5HdbEQePRoYGUdyBZSa8kDVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)