UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPGBJrGeDUASMw+WoxVCuQLuksTDO2blgAzvOd8Xcag='
WHERE
key_id = 'd50037c40ee23346ca8ddb1a5be5dd90ad50cbca28aa144e0e7956a383a9ac17'
AND (
token = 'YPGBJrGeDUASMw+WoxVCuQLuksTDO2blgAzvOd8Xcag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)