UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7wvSr19Xezjv+OeTa+eehEvF3vVR/t+oOnhc3VqtTE='
WHERE
key_id = 'cf03efc2af7a948c54bf810757e69fe66c8547034090756b30479a197c38e6b2'
AND (
token = 'G7wvSr19Xezjv+OeTa+eehEvF3vVR/t+oOnhc3VqtTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)