UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kL0V8jH8q9FDROJqc239jWWpMs4DC6ariya3KmhAhxY='
WHERE
key_id = '323f8ef50dc07e5e157161cc1e7844c209d45aacecbf9e4a857a767f1cc90d5a'
AND (
token = 'kL0V8jH8q9FDROJqc239jWWpMs4DC6ariya3KmhAhxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)